Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
TransactionID (FK)(PK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | |
LocationID (FK) | A unique system assigned identifier for the SellingLocation. | ID_LCN | Identity | integer | SellingLocation(LO_LCN_SL) |
RetailTransactionTypeCode (FK) | A retailer assigned code denoting a type of RetailTransaction. | CD_TYP_TRN_RTL | Code2 | char(2) | RetailTransactionType(CO_TYP_TRN_RTL) |
TillID (FK) | The unique identifier for the TENDER RESPOSITORY. | ID_RPSTY_TND | Identity | integer | Till(AS_TL) |
RingElapsedTime | The total time elapsed between commencement of the RetailTransaction and the commencement of the transaction tendering process. | IN_RNG_ELPSD | QuantityShortCountSeconds | decimal(5,0) | |
TenderElapsedTime | The total time taken to receive all the tender and complete the RetailTransaction. | IN_TND_ELPSD | QuantityShortCountSeconds | decimal(5,0) | |
IdleElapsedTime | The total time taken that a particular Workstation was idle between completion of the previous and commencement of the current RetailTransaction | IN_ELPSD_IDL | QuantityShortCountSeconds | decimal(5,0) | |
LockElapsedTime | The total time the workstation is in lock mode, ie securement of the WORKSTATION to prevent misuse by another party, between the previous and current RetailTransactions. | IN_LCK_ELPSD | QuantityShortCountSeconds | decimal(5,0) | |
UnitCount | The total number of individual ITEMs (SKU's) which are sold in the transaction | QU_UN_RTL_TRN | QuantityTransactionCount | decimal(7,0) | |
LineItemsScannedCount | The total number of individual ITEMs which are scanned at the point of sale, in comparison to those keyed. | QU_ITM_LN_SC | QuantityTransactionCount | decimal(7,0) | |
LineItemsScannedPercent | The total number of individual ITEMs which are scanned at the point of sale, as a percentage of the total data capture time. | PE_ITM_LN_SC | Percent | decimal(7,4) | |
LineItemsKeyedCount | the total number of ITEMs which are keyed at the point of sale in comparison to scanned. | QU_ITM_LN_KY | QuantityTransactionCount | decimal(7,0) | |
LineItemsKeyedPercent | The total number of individual ITEMs which are keyed at the point of sale, as a percentage of the total data capture time. | PE_ITM_LN_KY | Percent | decimal(7,4) | |
KeyDepartmentCount | The total number of ITEMs which are keyed by department at the point of sale. | QU_DPT_KY | QuantityTransactionCount | decimal(7,0) | |
KeyDepartmentPercent | The total number of individual ITEMs which are keyed by department at the point of sale, as a percentage of the total data capture time. | PE_DPT_KY | Percent | decimal(7,4) | |
ReceiptDateTime | The date and time that was printed on the receipt for this transaction. | TS_TRN_RCP | AuditDateTime | datetime | |
CustomerID (FK) | A unique system assigned identifier for the Customer. | ID_CT | Identity | integer | Customer(PA_CT) |
CustomerIDEntryMethodCode | Standardized code denoting how the CustomerID was captured for this RetailTransaction. Examples include: SCANNED - scanned from loyalty card or other retailer issued customer ID KEYED - manually entered from loyalty card ALT_ID_PHONE - no card presented, used phone number as alternate ID | CD_CT_ID_ENR_MTH | EntryMethodCode | varchar(20) | |
CustomerIDTypeCode | Designates the type of identification documentation provided by a customer for this retail transaction. This is used to tell how a customer verifies their identity to a retailer to establish an association between the retail transaction and a customer account. This provides a place to indicate that a customer identification action was taken independent of a tender or other mechanism to associate a customer with an account (and make them an identified customer). This helps for loyalty customers that pay in cash or other tender that has no retailer based account associated with it. The following codes are examples: ANONYMOUS - no ID, anonymous customer this means that there is no cust account relationship recorded for this retail transaction. LOYALTY_CARD - Loyalty membership card PHONE_NBR - phone number (to look up acct when a customer forgot their card CUST_CHG - Customer's retailer-provided charge card (not a bank card) CUST_LAYAWAY - Layaway receipt (or other evidence of a layaway acct) RENTAL - rental receipt or other evidence of a rental account | CD_CT_ID_TYP | Code | varchar(20) | |
ChannelID (FK) | Token Identifier for a channel instance | ID_CHNL | Identity | integer | Channel(CO_CHNL) |
RetailShoppingTripTypeCode (FK) | A code designating the purpose of the shopping trip that is related to a RetailTransaction. Examples: QUICKSTOP FILLIN STOCKUP | CD_RTL_SHPPG_TRP_TYP | Code | varchar(20) | RetailShoppingTripType(CO_RTL_SHPPG_TRP_TYP) |
TransactionEntryModeCode | A code that designates the privlege mode or level that the individual creating this transaction used. The purpose is to track illicit uses of manager and maintenance modes that might be used to circumvent normal operational and financial controls Sample values: NORMAL - lowest privilege level for cashiers MANAGER - intermeidate privilege level fo rmanagers MAINTENANCE - highest leve privilege for auditors, tax authorities and authorized POS maintenance indiviuals. | CD_TRN_ENR_MOD | Code | varchar(20) | |
ISOCurrencyCode (FK) | Currency code designated by ISO to identify national currency | CD_CNY_ISO_4217 | ISO_4217_CurrencyCode_char(3) | char(3) | ISO4217-CurrencyType(LU_CNY_ISO_4217) |
CustomerSurveyID (FK) | A unique retailer assigned identifier for the CustomerSurvery. | ID_SRVY_CT | Identity | integer | CustomerSurvey(DO_SRVY_CT) |